include("../dbinfo_inc.php"); $id=$_GET['id']; $urlsource=$_GET['url']; $table_people_groups=$table_people_groups; function find_name($id_person) { include("../dbinfo_inc.php"); mysql_connect($mysqlhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query_person="SELECT * FROM $table_people WHERE id_person='$id_person'"; $result_person=mysql_query($query_person); mysql_close (); if ($result_person) { $num_person=mysql_numrows($result_person);} else { $num_person=0;} $i_person=0; while ($i_person < $num_person) { $name_first=mysql_result($result_person,$i_person,"name_first"); $name_last=mysql_result($result_person,$i_person,"name_last"); $name_preferred=mysql_result($result_person,$i_person,"name_preferred"); ++$i_person; } if ($name_preferred) {$name_to_use = $name_preferred;} else {$name_to_use = $name_first;} return $name_to_use. " " . $name_last; } function find_group($id_group) { include("../dbinfo_inc.php"); mysql_connect($mysqlhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query_group="SELECT * FROM $table_groups WHERE id_group='$id_group'"; $result_group=mysql_query($query_group); mysql_close (); if ($result_group) { $num_group=mysql_numrows($result_group);} else { $num_group=0;} $i_group=0; while ($i_group < $num_group) { $name_group=mysql_result($result_group,$i_group,"name_group"); ++$i_group; } return $name_group; } if ($new_ud_people_group == "new") { $num_people_groups_ud="1"; } else { $query_people_groups_ud="SELECT * FROM $table_people_groups WHERE id_person_group='$id_person_group'"; mysql_connect($mysqlhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $result_people_groups_ud=mysql_query($query_people_groups_ud); mysql_close(); if ($result_people_groups_ud) {$num_people_groups_ud=mysql_numrows($result_people_groups_ud);} else {$num_people_groups_ud=0;} } $i_people_groups_ud=0; while ($i_people_groups_ud < $num_people_groups_ud) { if ($new_ud_people_group == "ud") { $id_person_group=mysql_result($result_people_groups_ud,$_people_groups_ud,"id_person_group"); $id_group=mysql_result($result_people_groups_ud,$i_people_groups_ud,"id_group"); $date_start_group=mysql_result($result_people_groups_ud,$i_people_groups_ud,"date_start_group"); $date_end_group=mysql_result($result_people_groups_ud,$i_people_groups_ud,"date_end_group"); $group_name=mysql_result($result_people_groups_ud,$i_people_groups_ud,"date_end_group"); $query_group="SELECT * FROM $table_groups WHERE id_group='$id_group'"; mysql_connect($mysqlhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $result_group=mysql_query($query_group); mysql_close(); if ($result_group) {$num_group=mysql_numrows($result_group);} else {$num_group=0;} if ($num_group == 1) { $type_group=mysql_result($result_group,$num_group - 1,"type_group"); $name_group=mysql_result($result_group,$num_group - 1,"name_group"); } } ?>